# [SQL]IN/NOT IN/EXISTS/NOT EXISTS的替代写法

## LEFT SEMI JOIN

## LEFT ANTI JOIN

## WHERE ()=1